sfc1
Pradeep H C
2024-10-10
Snowflake environment setup Creating snowflake trail account(02:41) Snowflake web console introduction part1(06:14) Snowflake web console introduction part2(03:54) Web console limitation(01:17) Creating database and table intro to sample data.(02:18) Section revise notes Snowflake architecture Snowflake architecture introduction.(02:16) Shared disk architecture.(01:18) Shared nothing architecture part 1(02:33) Shared nothing architecture part 2(02:40) Snowflake architecture revisit.(02:02) The impact.(00:58) Further reading Resources Caching in snowflake Introduction.(00:28) [Architecture demo] Caching in snowflake.(18:19) [Architecture demo] Caching revisit.(03:47) [Architecture demo] Lessons learned.(03:47) Clarifications(08:30) Clustering introduction.(00:29) Query processing in snowflake.(04:04) Micro partitions in snowflake.(01:54) Micro partitions depth.(02:25) [Demo] Applying clustering brief intro.(05:45) Clustering -- deep dive Section introduction.(00:37) [Demo] Checking clustering information(06:01) [Demo] How clustering works.(05:59) [Demo] Improve performance without applying clustering(02:22) [Demo] Manual re-clustering(03:16) [Demo] How to choose clustering keys.(04:28) Section Recap.(01:49) Snowflake clustering documentation. Virtual warehouse Introduction to virtual warehouse.(04:16) Virtual warehouse creation.(08:52) Scaling policy(03:30) Performance tuning and DB characterstics What is performance tuning in snowflake.(08:59) How query optimization works.(04:10) Concurrency control.(15:28) [Demo] How update transaction works.(02:33) [Demo] No constraints.(04:19) Q/A(11:36) Snowflake UI overview Introduction(01:21) Snowsight_overview_part1(10:25) Snowsight_overview_part2(07:18) Query acceleration service Introduction(01:20) Creating warehouse with QAS(02:22) Problem statement(05:47) QAS- Solution(03:39) QAS- Demo(03:10) QAS- scale factor(02:20) QAS- Eligible queries(04:03) Importent points(01:52) Search optimization service SOS introduction(01:49) Problem statement(04:37) SOS: Scenario-1(07:36) SOS: Scenario-2(06:27) SOS: Scenario-3(05:47) How SOS works(03:55) SOS: Summary(01:49) Query optimisation options(01:56) Optimization - outlook Basic understanding(06:49) ScaleUp vs ScaleOut(02:08) Query optimisation(06:36) Storage considerations.(01:50) As per documentation.(01:38) Business model(03:23) Warehouse monitor(03:28) Warehouse monitor:Demo(05:22) Budgets.(02:54) Snowflake architecture basics Virtual warehouse and UI Performacne optimization References Snowflake trail account link Quiz Assignment Snowflake SIGMOD paper Snowflake architecture documentation Quiz Quize 2 Quiz Snowflake CACHE Further reading Quiz Quiz 2 clustering Benefits of Defining Clustering Keys What is clustering key Considerations for Choosing Clustering for a Table Strategies for Selecting Clustering Keys Reclustering Quiz ASSIGNMENT FIX Quiz from documentation Snowfalke performance optimization Quiz References QAS documentation Quiz Quiz SOS snowflake documentation Snowflake optimization Warehouse resource monitor Quiz Snowflake virtual warehouse --outlook Warehouse idle time intro(01:03) Warehouse analogy(03:18) Metadata views(08:21) Snowflake warehouse dashboard Calculating idle cost(07:46) Adding dynamic filters(05:18) Creating dashboard intro(06:06) Warehouse utilization dashboard.(08:05) Analysis by warehouse(04:51) Analysis for under utilization(02:33) Analysis for over utilization(04:36) Building dashboard(01:30) Leveraging snowsight(06:15) Conclusion(01:31) Quiz Quiz Total run time : 3.5 hrs Number of lectures: 31 lectures Quiz: 7 quiz Questions : 64 questions Total run time : 2 hrs Number of lectures: 19 lectures Quiz: 2 quiz Questions : 17 questions Total run time : 2.3 hrs Number of lectures: 31 lectures Quiz: 4 quiz Questions : 32 questions Snowflake dashboard References virtual warehouse